Copyright ｩ1995, by Ken Sayward. All rights reserved.
Please send questions, comments and suggestions to Sayward@kagi.com
The latest version and documentation can be found on my AOL web page at http://users.aol.com/ksayward/
Version 1.3.0 - 14 Dec 95
- Added support for column widths. XTML will code the column widths as a percentage of the total table width,
based on the Excel formatting. Note that most (if not all) browsers will still muck around with the column
widths regardless of how specific you try to be.
- Now properly handles carriage returns within a cell (replaces them with <br> tags).
- Fixed a bug in the COLSPAN code which wasn't properly handling empty cells formatted as center- across-columns.
- Changed some internal references, so that there is no longer a restriction on the name of the add-in file.
- Changed the "About..." box to display the registered user name.
- Lots of code cleanup, resulting in faster execution, and better memory management.
- Implemented the Kagi shareware payment system. The included "Register" application allows shareware
payments via credit card, foreign currency, etc. Payments can also be made via email or Fax.
- Added a version resource (mac only). Shows up in Finder's 'get info...' window.
Version 1.2.2 - 11 Dec 95
- Fixed a bug in the substitution routine for accented and other special characters, where unwanted white space
was being added by XTML.
Version 1.2.1 - 8 Dec 95
- Fixed a bug in the prefs code when reading old prefs files (this one slipped through earlier today).
Version 1.2.0 - 8 Dec 95
- Added support for COLSPAN. Cells formatted with Excel's "center across selection" will get COLSPAN tags.
- Revised the output file saving routine to give more control over where the HTML file gets saved.
- Added a preference to suppress the file format warning after XTML processing is complete.
Version 1.1.5 - 4 Dec 95
- Added a substitution routine for accented and other special characters.
XTML now substitutes the appropriate "&xxxx;" codes. For example, the "" character is replaced with "é"
This substitution only occurs in the HTML output file.
Version 1.1.4 - 1 Dec 95
- Fixed a problem with the 'XTML Prefs' file for non-english versions of Excel.
- Added an option to add borders to blank cells.
XTML adds a " " (a nonbreaking space) in the HTML for that cell.
- Changed the table caption to acually use the <caption> tag. duh. :-)
Version 1.1.3 - 30 Nov 95
- Numbers formatted as currency or accounting were not getting default right alignment. Fixed.
- Changed the calculation of the default input range:
If the current selection is exactly one cell, then XTML attempts to determine the desired input range using the
'CurrentRegion' property. If the current selection is more than one cell, then the current selection is used.
- Some 'high-ASCII' characters were not displaying properly in Excel for Windows. Fixed.
- Changed file suffix default to '.htm' when running on Excel for Windows.
Default is still '.html' on the Mac.
- Registration dialog now displays reliably when requested from 'About...' dialog.
Version 1.1.2 - 28 Nov 95
- Added support for the Windows version of Excel.
The add-in file must be renamed as 'XTML.XLA'.
The prefs file ('XTMLPref.txt') is stored in the Excel application directory (Windows version only).
- Optimized some of the code for handling preferences. Speeds up the display of dialog boxes.
Version 1.1.1 - 28 Nov 95
- Added an 'XTML Prefs' file, which automatically gets created in your preferences folder.
Allows user selection of formatting tags for bold, italic, and bolditalic cells
stores user definition of which cell attributes to preserve when converting from Excel to HTML
- Changed the custom menu definitions
Now creates a submenu in the 'Tools' menu, but only when a Worksheet is the active sheet.
- Added an Aboutﾉ box.
- Added shareware registration code.
Version 1.0.4 - 25 Nov 95
- Now preserves Excel's numeric formats.
- Numeric cells will default to right aligned.
Version 1.0.3 - 24 Nov 95
- Re-wrote the output code to write directly to a new file. Previously, the output was being written to a scratch worksheet within the XTML Add-In, then being copied and pasted into the new output file. The new method speeds things up a bit, and makes the add-in file smaller. It also eliminates the possibility that the copy/paste operation would generate a memory alert.
Version 1.0.2 - 22 Nov 95
- Cleaned up the VBA code to make it more modular, and speed things up.
This should make it easier to add more functionality in the future.
Version 1.0.1 - 21 Nov 95
- Fixed a bug where the initial <body> tag wasn't getting written to the output file.
- Fixed a bug where table rows with HTML source greater than 255 characters were being truncated.
This was fixed by changing the output style to a more 'vertical' orientation (more carriage returns).
The downside is that the output filesize is slightly larger.
The upside is that the output file is probably easier to read and fine-tune.
- Changed the text of the finishing alert message to refer to the output file as 'formatted text (space delimited)'.
